home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 14 / Developer Source Volume 14 (I-MODE Publications, Inc.)(1999).iso / delpp / fig23-09.gif < prev    next >
Graphics Interchange Format  |  1996-11-19  |  11KB  |  593x454  |  1-bit (2 colors)
Labels: text | screenshot | display | number | font | parallel | black and white
OCR: B I $ % , Report Query - SQL x kva Tables Selections Sorting Derived Report Database fields variables grouping SQL SELECT 'CUSTOMERxDB''CustNo', 'CUSTOMERxDB'.'Company', CUSTOMERxDB''Addr1', 'CUSTOMERxDB''Addr2', CUSTOMERxDB'.'City', 'CUSTOMERxDB'.'State', 'CUSTOMERxDB'. Zip', CUSTOMERxDB'.'Country', 'CUSTOMERxDB'.'Phone', Copy CUSTOMERxDB''FAX', 'CUSTOMERxDB'.'TaxRate', CUSTOMERxDB'.'Contact', 'CUSTOMERxDB'.'LastInvoiceDate' ......... FROM Edit SQL c:\borland\delphi2\demos\data\CUSTOMER.DB' CUSTOMERxDB WHERE [['CUSTOMERxDB''State' = 'HI']]] GROUP BY CUSTOMERxDB''CustNo', 'CUSTOMERxDB'.'Company', CUSTOMERxDB''Addr1', 'CUSTOMERxDB''Addr2' CUSTOMERxDB'.'City', 'CUSTOMERxDB'.'State', 'CUSTOMERxDB'. Zip', CUSTOMERxDB'.'Country', 'CUSTOMERxDB'.'Phone', CUSTOMERxDB''FAX', 'CUSTOMERxDB'.'TaxRate', CUSTOMERxDB'.'Contact', 'CUSTOMERxDB'.'LastInvoiceDate' ORDER BY CUSTOMERxDB'.'Company' Done Cancel Help